package com.hualan.mapper;

import com.github.pagehelper.PageInfo;
import com.hualan.domain.Article;
import com.hualan.domain.ArticleAndTeacher;

import java.util.List;

/**
* @author 29524
* @description 针对表【article(文章表，存储所有文章信息)】的数据库操作Mapper
* @createDate 2024-09-05 11:44:33
* @Entity com.hualan.domain.Article
*/
public interface ArticleMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Article record);

    int insertSelective(Article record);

    Article selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Article record);

    int updateByPrimaryKey(Article record);

    //获取前三条数据
    List<Article> findThreeArticle();

    //模糊查找心理文章
    List<ArticleAndTeacher> findLikeArticle(String articleName);

    //获取所有文章
    List<Article> findAllArticle();

    //联表查询获取teacher type
    List<ArticleAndTeacher> findArticleAndTeacher();

}
